Entity DefinitionLogical Name : CustomerOrderStateAssignment |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| CustomerOrderID (FK)(PK) | A unique system assigned identifier for the CustomerOrder. | ID_ORD | Identity | integer | CustomerOrder(DO_CTORD) |
| CustomerOrderStateCode (FK)(PK) | A unique retailer assigned code denoting a potential state for a CustomerOrder. Eg: Create, DeleteItem, AddItem, ChangeItem, PartialDelivery, DeliveryComplete, PartialPickup, PickupComplete etc... | CD_STE_CTORD | Code2 | char(2) | CustomerOrderState(CO_STE_CTORD) |
| EffectiveDateTime | Date a given CustomerOrderStateAssignment becomes effective. This is used to facilitate a time lapsed view of customer order state changes. | DT_EF | EffectiveDateTime | datetime | |
| ExpirationDateTime | Date a given CustomerOrderStateAssignment expires. This is used to facilitate a time lapsed view of customer order state changes. | DT_EP | ExpirationDateTime | datetime |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| CustomerOrderState | is assigned via | CustomerOrderStateAssignment |
| CustomerOrder | is assigned | CustomerOrderStateAssignment |